package com.huike.clues.mapper;

import com.huike.clues.domain.SysNotice;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description TODO
 * @Author yy
 * @Date 2023-07-11 23:55
 */
@Mapper
public interface ISysNoticeMapper {


    /**
     * 获取系统提醒下拉列表
     * @param status
     * @return
     */
    List<SysNotice> NoticeList(String status) ;


    @Select("select * from sys_notice where notice_id =#{noticeId} ")
    SysNotice noticeId(Integer noticeId);

    @Select("update  sys_notice set status=1 where notice_id=#{noticeId}")
    void noticeById(Integer noticeId);

    /**
     * 获取系统提醒下拉列表
     * @param status
     * @return
     */
    List<SysNotice> pageList(String status);


    SysNotice findById(Integer noticeId);
}
